home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The 640 MEG Shareware Studio 2
/
The 640 Meg Shareware Studio CD-ROM Volume II (Data Express)(1993).ISO
/
mailers
/
eldat210.zip
/
EL_READ.ME
next >
Wrap
Text File
|
1991-07-01
|
4KB
|
103 lines
ELDATnnn.LZH
This distribution file contains comma-separated flat files of the
four main EchoList database tables. The EchoList and all derivative
reports, listings and tables are Copyright (c) 1991, Michael G. Fuchs.
You are free to use these files to produce reports or provide for
query facilities on your own system or BBS, so long as any derivative
reports carry my Copyright notice, and that the reports are not packaged
for re-distribution without prior consent of the Copyright holder.
EchoArea Table - Primary Conference information table. Note that this
table contains only the primary (first recorded) Moderator.
File: ELAREA.CSV
Table: echoarea
Column definitions
# Name Type Length
1 symbolic TEXT 20 characters
2 title TEXT 60 characters
3 modnamef TEXT 15 characters
4 modnamel TEXT 15 characters
5 modzone INTEGER
6 modnet INTEGER
7 modnode INTEGER
8 modpoint INTEGER
9 desc NOTE
10 distr NOTE
11 gateway NOTE
12 totnodes INTEGER
13 volume TEXT 10 characters
14 lastdate DATE
15 showname TEXT 1 characters
16 modperm TEXT 1 characters
17 sysopnly TEXT 1 characters
18 membship TEXT 1 characters
19 rulefile TEXT 13 characters
20 adddate DATE
Seen-by Table - Contains one row per "seen-by" node. User has the option
to omit the seennode field to shorten the list by only listing Nets.
File: ELSEEN.CSV
Table: seenby
Column definitions
# Name Type Length
1 symbolic TEXT 20 characters
2 seenzone INTEGER
3 seennet INTEGER
4 seennode INTEGER
5 seenpnt INTEGER
Path Table - Contains one row per bi-directional pair of nodes who
pass the conference. Node pairs are sorted lower-higher for storing
as "from-to", then duplicates are eliminated. So only one row ever
exists for each pair of nodes.
File: ELPATH.CSV
Table: path
Column definitions
# Name Type Length
1 symbolic TEXT 20 characters
2 fromzone INTEGER
3 fromnet INTEGER
4 fromnode INTEGER
5 frompnt INTEGER
6 tozone INTEGER
7 tonet INTEGER
8 tonode INTEGER
9 topnt INTEGER
Alternate Moderator Table - For conferences with more than one
moderator listed, this table will have one row for each ADDITIONAL
moderator (the primary from the echoarea table is not duplicated here,
although that's easy enough to do with most SQL-type DBMS's).
File: ELALTS.CSV
Table: altmods
Column definitions
# Name Type Length
1 symbolic TEXT 20 characters
2 modnamef TEXT 15 characters
3 modnamel TEXT 15 characters
4 modzone INTEGER
5 modnet INTEGER
6 modnode INTEGER
7 modpoint INTEGER
For non-R:base people:
- A null (missing value) field will be presented as -0-
- A NOTE field is a variable-length text field. It can be up to 4096 chars.
I'll look forward to suggestions from anyone who finds this service useful.
- Mike Fuchs
The EchoList Scribe
1:1/201 (1:266/71)